Dataset statistics
| Number of variables | 13 |
|---|---|
| Number of observations | 5061 |
| Missing cells | 2 |
| Missing cells (%) | < 0.1% |
| Duplicate rows | 0 |
| Duplicate rows (%) | 0.0% |
| Total size in memory | 514.1 KiB |
| Average record size in memory | 104.0 B |
Variable types
| NUM | 12 |
|---|---|
| DATE | 1 |
Reproduction
| Analysis started | 2020-07-07 19:30:16.312975 |
|---|---|
| Analysis finished | 2020-07-07 19:30:47.500818 |
| Duration | 31.19 seconds |
| Version | pandas-profiling v2.8.0 |
| Command line | pandas_profiling --config_file config.yaml [YOUR_FILE.csv] |
| Download configuration | config.yaml |
High is highly correlated with Open and 3 other fields | High correlation |
Open is highly correlated with High and 3 other fields | High correlation |
Low is highly correlated with Open and 3 other fields | High correlation |
Close is highly correlated with Open and 3 other fields | High correlation |
Turnover is highly correlated with Volume | High correlation |
Volume is highly correlated with Turnover | High correlation |
year is highly correlated with Open and 3 other fields | High correlation |
Date has unique values | Unique |
| Distinct count | 5061 |
|---|---|
| Unique (%) | 100.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 39.5 KiB |
| Minimum | 2000-01-03 00:00:00 |
|---|---|
| Maximum | 2020-05-08 00:00:00 |
Histogram
| Distinct count | 4959 |
|---|---|
| Unique (%) | 98.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 5216.23797668445 |
|---|---|
| Minimum | 853.0 |
| Maximum | 12430.5 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 39.5 KiB |
Quantile statistics
| Minimum | 853 |
|---|---|
| 5-th percentile | 1054.95 |
| Q1 | 1983.2 |
| median | 5096.7 |
| Q3 | 7895.4 |
| 95-th percentile | 11106.55 |
| Maximum | 12430.5 |
| Range | 11577.5 |
| Interquartile range (IQR) | 5912.2 |
Descriptive statistics
| Standard deviation | 3274.529979 |
|---|---|
| Coefficient of variation (CV) | 0.6277570144 |
| Kurtosis | -0.9093646122 |
| Mean | 5216.237977 |
| Median Absolute Deviation (MAD) | 2998.45 |
| Skewness | 0.4138808432 |
| Sum | 26399380.4 |
| Variance | 10722546.58 |
Histogram with fixed size bins (bins=10)
| Value | Count | Frequency (%) | |
| 1070.95 | 3 | 0.1% | |
| 1036.35 | 3 | 0.1% | |
| 2057.75 | 2 | < 0.1% | |
| 5688.45 | 2 | < 0.1% | |
| 1085.95 | 2 | < 0.1% | |
| 7636.05 | 2 | < 0.1% | |
| 962.85 | 2 | < 0.1% | |
| 5114.7 | 2 | < 0.1% | |
| 4166 | 2 | < 0.1% | |
| 972.05 | 2 | < 0.1% | |
| Other values (4949) | 5039 | 99.6% |
| Value | Count | Frequency (%) | |
| 853 | 1 | < 0.1% | |
| 861.35 | 1 | < 0.1% | |
| 869.15 | 1 | < 0.1% | |
| 872.15 | 1 | < 0.1% | |
| 873.15 | 1 | < 0.1% |
| Value | Count | Frequency (%) | |
| 12430.5 | 1 | < 0.1% | |
| 12349.4 | 1 | < 0.1% | |
| 12347.1 | 1 | < 0.1% | |
| 12333.1 | 1 | < 0.1% | |
| 12328.4 | 1 | < 0.1% |
| Distinct count | 4975 |
|---|---|
| Unique (%) | 98.3% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 5251.466666666666 |
|---|---|
| Minimum | 877.0 |
| Maximum | 12430.5 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 39.5 KiB |
Quantile statistics
| Minimum | 877 |
|---|---|
| 5-th percentile | 1063.7 |
| Q1 | 1999.7 |
| median | 5135.55 |
| Q3 | 7929.1 |
| 95-th percentile | 11146.9 |
| Maximum | 12430.5 |
| Range | 11553.5 |
| Interquartile range (IQR) | 5929.4 |
Descriptive statistics
| Standard deviation | 3283.745772 |
|---|---|
| Coefficient of variation (CV) | 0.625300698 |
| Kurtosis | -0.9116963277 |
| Mean | 5251.466667 |
| Median Absolute Deviation (MAD) | 3009 |
| Skewness | 0.407765243 |
| Sum | 26577672.8 |
| Variance | 10782986.3 |
Histogram with fixed size bins (bins=10)
| Value | Count | Frequency (%) | |
| 994.15 | 3 | 0.1% | |
| 1072 | 2 | < 0.1% | |
| 1837.95 | 2 | < 0.1% | |
| 964.2 | 2 | < 0.1% | |
| 5924.6 | 2 | < 0.1% | |
| 8229.4 | 2 | < 0.1% | |
| 1574.1 | 2 | < 0.1% | |
| 1070.15 | 2 | < 0.1% | |
| 1098.6 | 2 | < 0.1% | |
| 4434.45 | 2 | < 0.1% | |
| Other values (4965) | 5040 | 99.6% |
| Value | Count | Frequency (%) | |
| 877 | 1 | < 0.1% | |
| 878.6 | 1 | < 0.1% | |
| 893.05 | 1 | < 0.1% | |
| 893.35 | 1 | < 0.1% | |
| 903.75 | 1 | < 0.1% |
| Value | Count | Frequency (%) | |
| 12430.5 | 1 | < 0.1% | |
| 12389.05 | 1 | < 0.1% | |
| 12385.45 | 1 | < 0.1% | |
| 12374.25 | 1 | < 0.1% | |
| 12355.15 | 1 | < 0.1% |
| Distinct count | 4956 |
|---|---|
| Unique (%) | 97.9% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 5174.455008891523 |
|---|---|
| Minimum | 849.95 |
| Maximum | 12321.4 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 39.5 KiB |
Quantile statistics
| Minimum | 849.95 |
|---|---|
| 5-th percentile | 1045.55 |
| Q1 | 1964.65 |
| median | 5038.85 |
| Q3 | 7837.7 |
| 95-th percentile | 11037.85 |
| Maximum | 12321.4 |
| Range | 11471.45 |
| Interquartile range (IQR) | 5873.05 |
Descriptive statistics
| Standard deviation | 3257.303609 |
|---|---|
| Coefficient of variation (CV) | 0.6294969428 |
| Kurtosis | -0.9087343908 |
| Mean | 5174.455009 |
| Median Absolute Deviation (MAD) | 2972.3 |
| Skewness | 0.4181549213 |
| Sum | 26187916.8 |
| Variance | 10610026.8 |
Histogram with fixed size bins (bins=10)
| Value | Count | Frequency (%) | |
| 1043.3 | 3 | 0.1% | |
| 1034.1 | 3 | 0.1% | |
| 4143.25 | 2 | < 0.1% | |
| 2611.95 | 2 | < 0.1% | |
| 5975.55 | 2 | < 0.1% | |
| 1096.25 | 2 | < 0.1% | |
| 1071.35 | 2 | < 0.1% | |
| 1448.95 | 2 | < 0.1% | |
| 5910.95 | 2 | < 0.1% | |
| 1355.35 | 2 | < 0.1% | |
| Other values (4946) | 5039 | 99.6% |
| Value | Count | Frequency (%) | |
| 849.95 | 1 | < 0.1% | |
| 853 | 1 | < 0.1% | |
| 858.85 | 1 | < 0.1% | |
| 859.2 | 1 | < 0.1% | |
| 861.05 | 1 | < 0.1% |
| Value | Count | Frequency (%) | |
| 12321.4 | 1 | < 0.1% | |
| 12315.8 | 1 | < 0.1% | |
| 12308.7 | 1 | < 0.1% | |
| 12285.8 | 1 | < 0.1% | |
| 12278.75 | 1 | < 0.1% |
| Distinct count | 4947 |
|---|---|
| Unique (%) | 97.7% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 5213.433768030034 |
|---|---|
| Minimum | 854.2 |
| Maximum | 12362.3 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 39.5 KiB |
Quantile statistics
| Minimum | 854.2 |
|---|---|
| 5-th percentile | 1054.8 |
| Q1 | 1982.75 |
| median | 5090.85 |
| Q3 | 7887.8 |
| 95-th percentile | 11105.35 |
| Maximum | 12362.3 |
| Range | 11508.1 |
| Interquartile range (IQR) | 5905.05 |
Descriptive statistics
| Standard deviation | 3270.073955 |
|---|---|
| Coefficient of variation (CV) | 0.6272399536 |
| Kurtosis | -0.9106763981 |
| Mean | 5213.433768 |
| Median Absolute Deviation (MAD) | 2995.95 |
| Skewness | 0.4122485421 |
| Sum | 26385188.3 |
| Variance | 10693383.67 |
Histogram with fixed size bins (bins=10)
| Value | Count | Frequency (%) | |
| 1067 | 3 | 0.1% | |
| 954.75 | 3 | 0.1% | |
| 5274.85 | 3 | 0.1% | |
| 5486.15 | 3 | 0.1% | |
| 1070.65 | 3 | 0.1% | |
| 1110.45 | 3 | 0.1% | |
| 963.25 | 2 | < 0.1% | |
| 4359.3 | 2 | < 0.1% | |
| 1286.75 | 2 | < 0.1% | |
| 1358.05 | 2 | < 0.1% | |
| Other values (4937) | 5035 | 99.5% |
| Value | Count | Frequency (%) | |
| 854.2 | 1 | < 0.1% | |
| 861.4 | 1 | < 0.1% | |
| 869.05 | 1 | < 0.1% | |
| 872.25 | 1 | < 0.1% | |
| 873.7 | 1 | < 0.1% |
| Value | Count | Frequency (%) | |
| 12362.3 | 1 | < 0.1% | |
| 12355.5 | 1 | < 0.1% | |
| 12352.35 | 1 | < 0.1% | |
| 12343.3 | 1 | < 0.1% | |
| 12329.55 | 1 | < 0.1% |
| Distinct count | 5059 |
|---|---|
| Unique (%) | > 99.9% |
| Missing | 1 |
| Missing (%) | < 0.1% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 166441646.00790513 |
|---|---|
| Minimum | 1394931.0 |
| Maximum | 1811564187.0 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 39.5 KiB |
Quantile statistics
| Minimum | 1394931 |
|---|---|
| 5-th percentile | 38776031.4 |
| Q1 | 77723025.75 |
| median | 137086023 |
| Q3 | 198302099 |
| 95-th percentile | 415238071.3 |
| Maximum | 1811564187 |
| Range | 1810169256 |
| Interquartile range (IQR) | 120579073.2 |
Descriptive statistics
| Standard deviation | 141956679.2 |
|---|---|
| Coefficient of variation (CV) | 0.8528915845 |
| Kurtosis | 18.65450862 |
| Mean | 166441646 |
| Median Absolute Deviation (MAD) | 60112828.5 |
| Skewness | 3.298774292 |
| Sum | 8.421947288e+11 |
| Variance | 2.015169877e+16 |
Histogram with fixed size bins (bins=10)
| Value | Count | Frequency (%) | |
| 223135459 | 2 | < 0.1% | |
| 122278698 | 1 | < 0.1% | |
| 525674715 | 1 | < 0.1% | |
| 45786733 | 1 | < 0.1% | |
| 149592578 | 1 | < 0.1% | |
| 63804437 | 1 | < 0.1% | |
| 107481297 | 1 | < 0.1% | |
| 44738447 | 1 | < 0.1% | |
| 231382790 | 1 | < 0.1% | |
| 125128736 | 1 | < 0.1% | |
| Other values (5049) | 5049 | 99.8% |
| Value | Count | Frequency (%) | |
| 1394931 | 1 | < 0.1% | |
| 2768292 | 1 | < 0.1% | |
| 6555703 | 1 | < 0.1% | |
| 7991165 | 1 | < 0.1% | |
| 9774392 | 1 | < 0.1% |
| Value | Count | Frequency (%) | |
| 1811564187 | 1 | < 0.1% | |
| 1566119057 | 1 | < 0.1% | |
| 1517275761 | 1 | < 0.1% | |
| 1414837250 | 1 | < 0.1% | |
| 1389061775 | 1 | < 0.1% |
| Distinct count | 5054 |
|---|---|
| Unique (%) | 99.9% |
| Missing | 1 |
| Missing (%) | < 0.1% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 68261867766.798416 |
|---|---|
| Minimum | 401200000.0 |
| Maximum | 597055300000.0 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 39.5 KiB |
Quantile statistics
| Minimum | 401200000 |
|---|---|
| 5-th percentile | 1.1863665e+10 |
| Q1 | 3.0176425e+10 |
| median | 5.79317e+10 |
| Q3 | 8.4935175e+10 |
| 95-th percentile | 1.8085872e+11 |
| Maximum | 5.970553e+11 |
| Range | 5.966541e+11 |
| Interquartile range (IQR) | 5.475875e+10 |
Descriptive statistics
| Standard deviation | 5.482144334e+10 |
|---|---|
| Coefficient of variation (CV) | 0.8031049418 |
| Kurtosis | 8.215151231 |
| Mean | 6.826186777e+10 |
| Median Absolute Deviation (MAD) | 2.743195e+10 |
| Skewness | 2.203935298 |
| Sum | 3.454050509e+14 |
| Variance | 3.00539065e+21 |
Histogram with fixed size bins (bins=10)
| Value | Count | Frequency (%) | |
| 1.096895e+11 | 2 | < 0.1% | |
| 9929300000 | 2 | < 0.1% | |
| 1.38814e+10 | 2 | < 0.1% | |
| 2.50291e+10 | 2 | < 0.1% | |
| 2.82538e+10 | 2 | < 0.1% | |
| 5.25239e+10 | 2 | < 0.1% | |
| 9.59185e+10 | 1 | < 0.1% | |
| 1.113904e+11 | 1 | < 0.1% | |
| 2.74691e+10 | 1 | < 0.1% | |
| 8.19595e+10 | 1 | < 0.1% | |
| Other values (5044) | 5044 | 99.7% |
| Value | Count | Frequency (%) | |
| 401200000 | 1 | < 0.1% | |
| 1139900000 | 1 | < 0.1% | |
| 2896000000 | 1 | < 0.1% | |
| 2978900000 | 1 | < 0.1% | |
| 3557400000 | 1 | < 0.1% |
| Value | Count | Frequency (%) | |
| 5.970553e+11 | 1 | < 0.1% | |
| 5.408153e+11 | 1 | < 0.1% | |
| 4.603062e+11 | 1 | < 0.1% | |
| 4.416789e+11 | 1 | < 0.1% | |
| 4.187864e+11 | 1 | < 0.1% |
P/E
Real number (ℝ≥0)
| Distinct count | 1576 |
|---|---|
| Unique (%) | 31.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 20.03701442402687 |
|---|---|
| Minimum | 10.68 |
| Maximum | 29.9 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 39.5 KiB |
Quantile statistics
| Minimum | 10.68 |
|---|---|
| 5-th percentile | 13.51 |
| Q1 | 17.11 |
| median | 20.09 |
| Q3 | 22.86 |
| 95-th percentile | 27.32 |
| Maximum | 29.9 |
| Range | 19.22 |
| Interquartile range (IQR) | 5.75 |
Descriptive statistics
| Standard deviation | 4.194021036 |
|---|---|
| Coefficient of variation (CV) | 0.2093136705 |
| Kurtosis | -0.6892830683 |
| Mean | 20.03701442 |
| Median Absolute Deviation (MAD) | 2.89 |
| Skewness | 0.1375321807 |
| Sum | 101407.33 |
| Variance | 17.58981245 |
Histogram with fixed size bins (bins=10)
| Value | Count | Frequency (%) | |
| 20.82 | 14 | 0.3% | |
| 20.58 | 12 | 0.2% | |
| 18.38 | 11 | 0.2% | |
| 21.19 | 11 | 0.2% | |
| 18.66 | 11 | 0.2% | |
| 20.31 | 10 | 0.2% | |
| 18.28 | 10 | 0.2% | |
| 20.34 | 10 | 0.2% | |
| 17.85 | 10 | 0.2% | |
| 21.59 | 10 | 0.2% | |
| Other values (1566) | 4952 | 97.8% |
| Value | Count | Frequency (%) | |
| 10.68 | 1 | < 0.1% | |
| 10.84 | 1 | < 0.1% | |
| 10.86 | 2 | < 0.1% | |
| 10.9 | 1 | < 0.1% | |
| 10.93 | 1 | < 0.1% |
| Value | Count | Frequency (%) | |
| 29.9 | 1 | < 0.1% | |
| 29.73 | 1 | < 0.1% | |
| 29.69 | 1 | < 0.1% | |
| 29.68 | 1 | < 0.1% | |
| 29.65 | 1 | < 0.1% |
P/B
Real number (ℝ≥0)
| Distinct count | 418 |
|---|---|
| Unique (%) | 8.3% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 3.54745900019759 |
|---|---|
| Minimum | 1.92 |
| Maximum | 6.55 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 39.5 KiB |
Quantile statistics
| Minimum | 1.92 |
|---|---|
| 5-th percentile | 2.36 |
| Q1 | 3.03 |
| median | 3.47 |
| Q3 | 3.79 |
| 95-th percentile | 5.21 |
| Maximum | 6.55 |
| Range | 4.63 |
| Interquartile range (IQR) | 0.76 |
Descriptive statistics
| Standard deviation | 0.7992038433 |
|---|---|
| Coefficient of variation (CV) | 0.2252890994 |
| Kurtosis | 1.055125527 |
| Mean | 3.547459 |
| Median Absolute Deviation (MAD) | 0.39 |
| Skewness | 0.9052240412 |
| Sum | 17953.69 |
| Variance | 0.6387267832 |
Histogram with fixed size bins (bins=10)
| Value | Count | Frequency (%) | |
| 3.44 | 55 | 1.1% | |
| 3.52 | 52 | 1.0% | |
| 3.57 | 49 | 1.0% | |
| 3.45 | 49 | 1.0% | |
| 3.48 | 48 | 0.9% | |
| 3.49 | 48 | 0.9% | |
| 3.58 | 48 | 0.9% | |
| 3.5 | 46 | 0.9% | |
| 3.4 | 46 | 0.9% | |
| 3.7 | 46 | 0.9% | |
| Other values (408) | 4574 | 90.4% |
| Value | Count | Frequency (%) | |
| 1.92 | 1 | < 0.1% | |
| 1.94 | 1 | < 0.1% | |
| 1.96 | 1 | < 0.1% | |
| 1.97 | 2 | < 0.1% | |
| 2.01 | 1 | < 0.1% |
| Value | Count | Frequency (%) | |
| 6.55 | 1 | < 0.1% | |
| 6.54 | 1 | < 0.1% | |
| 6.53 | 2 | < 0.1% | |
| 6.47 | 1 | < 0.1% | |
| 6.46 | 1 | < 0.1% |
Div Yield
Real number (ℝ≥0)
| Distinct count | 236 |
|---|---|
| Unique (%) | 4.7% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1.428164394388461 |
|---|---|
| Minimum | 0.59 |
| Maximum | 3.18 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 39.5 KiB |
Quantile statistics
| Minimum | 0.59 |
|---|---|
| 5-th percentile | 0.95 |
| Q1 | 1.18 |
| median | 1.33 |
| Q3 | 1.55 |
| 95-th percentile | 2.28 |
| Maximum | 3.18 |
| Range | 2.59 |
| Interquartile range (IQR) | 0.37 |
Descriptive statistics
| Standard deviation | 0.4023795937 |
|---|---|
| Coefficient of variation (CV) | 0.2817459917 |
| Kurtosis | 2.544773961 |
| Mean | 1.428164394 |
| Median Absolute Deviation (MAD) | 0.19 |
| Skewness | 1.454176845 |
| Sum | 7227.94 |
| Variance | 0.1619093374 |
Histogram with fixed size bins (bins=10)
| Value | Count | Frequency (%) | |
| 1.25 | 155 | 3.1% | |
| 1.26 | 118 | 2.3% | |
| 1.27 | 111 | 2.2% | |
| 1.22 | 109 | 2.2% | |
| 1.23 | 105 | 2.1% | |
| 1.24 | 100 | 2.0% | |
| 1.28 | 84 | 1.7% | |
| 1.29 | 82 | 1.6% | |
| 1.36 | 79 | 1.6% | |
| 1.42 | 78 | 1.5% | |
| Other values (226) | 4040 | 79.8% |
| Value | Count | Frequency (%) | |
| 0.59 | 2 | < 0.1% | |
| 0.6 | 6 | 0.1% | |
| 0.61 | 7 | 0.1% | |
| 0.62 | 4 | 0.1% | |
| 0.63 | 2 | < 0.1% |
| Value | Count | Frequency (%) | |
| 3.18 | 1 | < 0.1% | |
| 3.17 | 2 | < 0.1% | |
| 3.16 | 1 | < 0.1% | |
| 3.15 | 2 | < 0.1% | |
| 3.13 | 1 | < 0.1% |
| Distinct count | 21 |
|---|---|
| Unique (%) | 0.4% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 2009.6437462951985 |
|---|---|
| Minimum | 2000 |
| Maximum | 2020 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 39.5 KiB |
Quantile statistics
| Minimum | 2000 |
|---|---|
| 5-th percentile | 2001 |
| Q1 | 2005 |
| median | 2010 |
| Q3 | 2015 |
| 95-th percentile | 2019 |
| Maximum | 2020 |
| Range | 20 |
| Interquartile range (IQR) | 10 |
Descriptive statistics
| Standard deviation | 5.877213225 |
|---|---|
| Coefficient of variation (CV) | 0.00292450502 |
| Kurtosis | -1.199090787 |
| Mean | 2009.643746 |
| Median Absolute Deviation (MAD) | 5 |
| Skewness | 0.01463027409 |
| Sum | 10170807 |
| Variance | 34.54163529 |
Histogram with fixed size bins (bins=10)
| Value | Count | Frequency (%) | |
| 2004 | 254 | 5.0% | |
| 2003 | 254 | 5.0% | |
| 2010 | 252 | 5.0% | |
| 2012 | 251 | 5.0% | |
| 2002 | 251 | 5.0% | |
| 2005 | 251 | 5.0% | |
| 2000 | 250 | 4.9% | |
| 2013 | 250 | 4.9% | |
| 2006 | 250 | 4.9% | |
| 2007 | 249 | 4.9% | |
| Other values (11) | 2549 | 50.4% |
| Value | Count | Frequency (%) | |
| 2000 | 250 | 4.9% | |
| 2001 | 248 | 4.9% | |
| 2002 | 251 | 5.0% | |
| 2003 | 254 | 5.0% | |
| 2004 | 254 | 5.0% |
| Value | Count | Frequency (%) | |
| 2020 | 87 | 1.7% | |
| 2019 | 245 | 4.8% | |
| 2018 | 246 | 4.9% | |
| 2017 | 248 | 4.9% | |
| 2016 | 247 | 4.9% |
month
Real number (ℝ≥0)
| Distinct count | 12 |
|---|---|
| Unique (%) | 0.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 6.441414740169927 |
|---|---|
| Minimum | 1 |
| Maximum | 12 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 39.5 KiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 3 |
| median | 6 |
| Q3 | 9 |
| 95-th percentile | 12 |
| Maximum | 12 |
| Range | 11 |
| Interquartile range (IQR) | 6 |
Descriptive statistics
| Standard deviation | 3.452497506 |
|---|---|
| Coefficient of variation (CV) | 0.535984352 |
| Kurtosis | -1.203710545 |
| Mean | 6.44141474 |
| Median Absolute Deviation (MAD) | 3 |
| Skewness | 0.01801769596 |
| Sum | 32600 |
| Variance | 11.91973903 |
Histogram with fixed size bins (bins=10)
| Value | Count | Frequency (%) | |
| 1 | 448 | 8.9% | |
| 7 | 439 | 8.7% | |
| 5 | 435 | 8.6% | |
| 3 | 433 | 8.6% | |
| 6 | 427 | 8.4% | |
| 8 | 421 | 8.3% | |
| 12 | 419 | 8.3% | |
| 2 | 415 | 8.2% | |
| 9 | 409 | 8.1% | |
| 10 | 408 | 8.1% | |
| Other values (2) | 807 | 15.9% |
| Value | Count | Frequency (%) | |
| 1 | 448 | 8.9% | |
| 2 | 415 | 8.2% | |
| 3 | 433 | 8.6% | |
| 4 | 403 | 8.0% | |
| 5 | 435 | 8.6% |
| Value | Count | Frequency (%) | |
| 12 | 419 | 8.3% | |
| 11 | 404 | 8.0% | |
| 10 | 408 | 8.1% | |
| 9 | 409 | 8.1% | |
| 8 | 421 | 8.3% |
day
Real number (ℝ≥0)
| Distinct count | 31 |
|---|---|
| Unique (%) | 0.6% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 15.791345583876705 |
|---|---|
| Minimum | 1 |
| Maximum | 31 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 39.5 KiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 2 |
| Q1 | 8 |
| median | 16 |
| Q3 | 23 |
| 95-th percentile | 30 |
| Maximum | 31 |
| Range | 30 |
| Interquartile range (IQR) | 15 |
Descriptive statistics
| Standard deviation | 8.783717205 |
|---|---|
| Coefficient of variation (CV) | 0.5562361458 |
| Kurtosis | -1.196499001 |
| Mean | 15.79134558 |
| Median Absolute Deviation (MAD) | 8 |
| Skewness | 0.01089232119 |
| Sum | 79920 |
| Variance | 77.15368793 |
Histogram with fixed size bins (bins=10)
| Value | Count | Frequency (%) | |
| 7 | 173 | 3.4% | |
| 4 | 172 | 3.4% | |
| 11 | 172 | 3.4% | |
| 28 | 172 | 3.4% | |
| 5 | 172 | 3.4% | |
| 27 | 172 | 3.4% | |
| 23 | 171 | 3.4% | |
| 3 | 171 | 3.4% | |
| 16 | 170 | 3.4% | |
| 20 | 170 | 3.4% | |
| Other values (21) | 3346 | 66.1% |
| Value | Count | Frequency (%) | |
| 1 | 153 | 3.0% | |
| 2 | 148 | 2.9% | |
| 3 | 171 | 3.4% | |
| 4 | 172 | 3.4% | |
| 5 | 172 | 3.4% |
| Value | Count | Frequency (%) | |
| 31 | 102 | 2.0% | |
| 30 | 155 | 3.1% | |
| 29 | 156 | 3.1% | |
| 28 | 172 | 3.4% | |
| 27 | 172 | 3.4% |
Pearson's r
The Pearson's correlation coefficient (r) is a measure of linear correlation between two variables. It's value lies between -1 and +1, -1 indicating total negative linear correlation, 0 indicating no linear correlation and 1 indicating total positive linear correlation. Furthermore, r is invariant under separate changes in location and scale of the two variables, implying that for a linear function the angle to the x-axis does not affect r.To calculate r for two variables X and Y, one divides the covariance of X and Y by the product of their standard deviations.
Spearman's ρ
The Spearman's rank correlation coefficient (ρ) is a measure of monotonic correlation between two variables, and is therefore better in catching nonlinear monotonic correlations than Pearson's r. It's value lies between -1 and +1, -1 indicating total negative monotonic correlation, 0 indicating no monotonic correlation and 1 indicating total positive monotonic correlation.To calculate ρ for two variables X and Y, one divides the covariance of the rank variables of X and Y by the product of their standard deviations.
Kendall's τ
Similarly to Spearman's rank correlation coefficient, the Kendall rank correlation coefficient (τ) measures ordinal association between two variables. It's value lies between -1 and +1, -1 indicating total negative correlation, 0 indicating no correlation and 1 indicating total positive correlation.To calculate τ for two variables X and Y, one determines the number of concordant and discordant pairs of observations. τ is given by the number of concordant pairs minus the discordant pairs divided by the total number of pairs.
Phik (φk)
Phik (φk) is a new and practical correlation coefficient that works consistently between categorical, ordinal and interval variables, captures non-linear dependency and reverts to the Pearson correlation coefficient in case of a bivariate normal input distribution. There is extensive documentation available here.First rows
| Date | Open | High | Low | Close | Volume | Turnover | P/E | P/B | Div Yield | year | month | day | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | 2000-01-03 | 1482.15 | 1592.90 | 1482.15 | 1592.20 | 25358322.0 | 8.841500e+09 | 25.91 | 4.63 | 0.95 | 2000 | 1 | 3 |
| 1 | 2000-01-04 | 1594.40 | 1641.95 | 1594.40 | 1638.70 | 38787872.0 | 1.973690e+10 | 26.67 | 4.76 | 0.92 | 2000 | 1 | 4 |
| 2 | 2000-01-05 | 1634.55 | 1635.50 | 1555.05 | 1595.80 | 62153431.0 | 3.084790e+10 | 25.97 | 4.64 | 0.95 | 2000 | 1 | 5 |
| 3 | 2000-01-06 | 1595.80 | 1639.00 | 1595.80 | 1617.60 | 51272875.0 | 2.531180e+10 | 26.32 | 4.70 | 0.94 | 2000 | 1 | 6 |
| 4 | 2000-01-07 | 1616.60 | 1628.25 | 1597.20 | 1613.30 | 54315945.0 | 1.914630e+10 | 26.25 | 4.69 | 0.94 | 2000 | 1 | 7 |
| 5 | 2000-01-10 | 1615.65 | 1662.10 | 1614.95 | 1632.95 | 45013949.0 | 2.375350e+10 | 26.57 | 4.74 | 0.93 | 2000 | 1 | 10 |
| 6 | 2000-01-11 | 1633.25 | 1639.90 | 1548.25 | 1572.50 | 49120254.0 | 2.596950e+10 | 25.59 | 4.57 | 0.96 | 2000 | 1 | 11 |
| 7 | 2000-01-12 | 1572.30 | 1631.55 | 1571.70 | 1624.80 | 38364961.0 | 1.895000e+10 | 26.44 | 4.72 | 0.93 | 2000 | 1 | 12 |
| 8 | 2000-01-13 | 1627.85 | 1671.15 | 1613.65 | 1621.40 | 44738447.0 | 2.237610e+10 | 26.38 | 4.71 | 0.93 | 2000 | 1 | 13 |
| 9 | 2000-01-14 | 1622.15 | 1627.40 | 1591.40 | 1622.75 | 43292009.0 | 1.979980e+10 | 26.41 | 4.71 | 0.93 | 2000 | 1 | 14 |
Last rows
| Date | Open | High | Low | Close | Volume | Turnover | P/E | P/B | Div Yield | year | month | day | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 5051 | 2020-04-24 | 9163.90 | 9296.90 | 9141.30 | 9154.40 | 659439249.0 | 3.285905e+11 | 20.48 | 2.61 | 1.66 | 2020 | 4 | 24 |
| 5052 | 2020-04-27 | 9259.70 | 9377.10 | 9250.35 | 9282.30 | 512793298.0 | 2.669654e+11 | 20.77 | 2.65 | 1.64 | 2020 | 4 | 27 |
| 5053 | 2020-04-28 | 9389.80 | 9404.40 | 9260.00 | 9380.90 | 614548983.0 | 3.009141e+11 | 21.00 | 2.67 | 1.62 | 2020 | 4 | 28 |
| 5054 | 2020-04-29 | 9408.60 | 9599.85 | 9392.35 | 9553.35 | 653026950.0 | 3.167323e+11 | 21.65 | 2.72 | 1.59 | 2020 | 4 | 29 |
| 5055 | 2020-04-30 | 9753.50 | 9889.05 | 9731.50 | 9859.90 | 931173802.0 | 3.933246e+11 | 22.35 | 2.81 | 1.54 | 2020 | 4 | 30 |
| 5056 | 2020-05-04 | 9533.50 | 9533.50 | 9266.95 | 9293.50 | NaN | NaN | 21.39 | 2.65 | 1.64 | 2020 | 5 | 4 |
| 5057 | 2020-05-05 | 9429.40 | 9450.90 | 9190.75 | 9205.60 | 725196178.0 | 2.970020e+11 | 21.19 | 2.62 | 1.65 | 2020 | 5 | 5 |
| 5058 | 2020-05-06 | 9226.80 | 9346.90 | 9116.50 | 9270.90 | 722185448.0 | 3.079810e+11 | 21.34 | 2.64 | 1.64 | 2020 | 5 | 6 |
| 5059 | 2020-05-07 | 9234.05 | 9277.85 | 9175.90 | 9199.05 | 708740416.0 | 5.970553e+11 | 21.18 | 2.62 | 1.65 | 2020 | 5 | 7 |
| 5060 | 2020-05-08 | 9376.95 | 9382.65 | 9238.20 | 9251.50 | 609053504.0 | 3.074345e+11 | 21.28 | 2.64 | 1.64 | 2020 | 5 | 8 |